UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D3QU35U0L9LaA4K6Y4MjULJvDra3LYkpu4KD4fi6+2s='
WHERE
key_id = '1057ca391e7cdbc98c45e94795793912e9f4cd6b98a60992695df7006e36059b'
AND (
token = 'D3QU35U0L9LaA4K6Y4MjULJvDra3LYkpu4KD4fi6+2s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)