UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dxp+CFgF++oDjj39nz/Ap/gKl9GclscIT4vIAM4jhuM='
WHERE
key_id = '0646004adecb5333e7f5cf118ed81ce87cafff86fcea441076715e92cb14773e'
AND (
token = 'dxp+CFgF++oDjj39nz/Ap/gKl9GclscIT4vIAM4jhuM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)