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