UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oHO6ddUWkso35367jEqIVYLbdGwC1vV5AJF/G2JdfVs='
WHERE
key_id = 'd12ac9bde480f4265f839aba5b99a6dc9255ebff8e07c2fccb6a9d8e16c9cf38'
AND (
token = 'oHO6ddUWkso35367jEqIVYLbdGwC1vV5AJF/G2JdfVs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)