UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5HowKCtG7qcMXntyhIT3nvAIwImRLBSERm03L+x8JmU='
WHERE
key_id = '8a99416397c6bd549671171deabc86c52e078c9b05422d26d4902599a376f2b5'
AND (
token = '5HowKCtG7qcMXntyhIT3nvAIwImRLBSERm03L+x8JmU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)