UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z0aGvcR2eNcsiec8A5DQgjwwA/uXLVWxO7CXxiUXP/4='
WHERE
key_id = '307ce8e2c938c6e3f82158e088ca037770b30f93bd935b0880196f8f302d7d10'
AND (
token = 'z0aGvcR2eNcsiec8A5DQgjwwA/uXLVWxO7CXxiUXP/4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)