UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'a4JAvyIUz9SLCe4ukpK4Q6fcRcHhbS13fisZWDszfCs='
WHERE
key_id = '38f8051366a58d894392f9ae0777e10ec9373e1f42380b0721fd400a6cc9c437'
AND (
token = 'a4JAvyIUz9SLCe4ukpK4Q6fcRcHhbS13fisZWDszfCs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)