UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ycu6NyDTugs9kNFv8NCM97+N/QFJb4FPr4fDOJ50HoA='
WHERE
key_id = 'b1c8e200fd4af07215cc813a0b113eeee9918fe73b383cdb522038cb652f2a93'
AND (
token = 'ycu6NyDTugs9kNFv8NCM97+N/QFJb4FPr4fDOJ50HoA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)