UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lZZlLWf9CFh8DjkRdtO4s0HLOLHj4kZPShjDb9vl6TQ='
WHERE
key_id = 'c591608945837525dd11e1aa9d8ed933693e482653cf99b3d9eb6f12030ffec0'
AND (
token = 'lZZlLWf9CFh8DjkRdtO4s0HLOLHj4kZPShjDb9vl6TQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)