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