UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '42kCTAUGw3C999qMzUX4X/WIriF3zV5bVoI62S2LE6E='
WHERE
key_id = 'b0c5c3061bf7656b79a6c77f1f1ca1b499376d4eb487d52ab4e62da06b14ebfb'
AND (
token = '42kCTAUGw3C999qMzUX4X/WIriF3zV5bVoI62S2LE6E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)