UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gPFokBtpRKv4mvqoxkl6NtsHlDnc3DgL+zORK6HOjC0='
WHERE
key_id = '20bf41f2083b559b0f6c0df6512589ffce6a880f4f8c22536f76617572c31733'
AND (
token = 'gPFokBtpRKv4mvqoxkl6NtsHlDnc3DgL+zORK6HOjC0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)