UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/5o7R04t9pqgQREj1NmtCB74sJx0k8mWoyXD79bmo/o='
WHERE
key_id = '3e6719940244ac946c17cf574b7012229a06cef8da3cfb5a7854d42f1f902663'
AND (
token = '/5o7R04t9pqgQREj1NmtCB74sJx0k8mWoyXD79bmo/o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)