UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9IycTj9Fz6FY9HBC1GDa86naEOPRdaJEtZheZWr1MGU='
WHERE
key_id = '5be9bb040407cb149d3520a9d1b8315a50323cdf5788b547e2a31d6ced3bafe6'
AND (
token = '9IycTj9Fz6FY9HBC1GDa86naEOPRdaJEtZheZWr1MGU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)