UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'os6p5in3rgnIm9QQ0bpgJja0kTxcKQ/cQu5e/S9NJC0='
WHERE
key_id = 'c547ac543a0c91ace1acd26979a4002135a1ee48e20a00eea24de90bdaec96a5'
AND (
token = 'os6p5in3rgnIm9QQ0bpgJja0kTxcKQ/cQu5e/S9NJC0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)