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