UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bt1l7SaO1gZqD9kpiU6HYLSERKGKTiWC81sWFTv4/ro='
WHERE
key_id = 'd595f241cbbe12b74f97ca1efaca5abf0211eb1e6bc1dffa6426a55996477cce'
AND (
token = 'bt1l7SaO1gZqD9kpiU6HYLSERKGKTiWC81sWFTv4/ro='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)