UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qOKwYyD+vx/EBgdxAl674OVNkch2KW7JE4J1L/zcZus='
WHERE
key_id = 'e42228b8ef1df9fd514ffdcfa2af7c6f63d2d922fdc55fc65da282bb95cadb26'
AND (
token = 'qOKwYyD+vx/EBgdxAl674OVNkch2KW7JE4J1L/zcZus='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)