UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'mTs/gyyjAeVMUCRGJDAbDIaqPDIKEYB9eBktW1Ml2NE='
WHERE
key_id = '78cae18c09432601b0a6d63704778893182753e4134a64a1105ffb6c70f0b330'
AND (
token = 'mTs/gyyjAeVMUCRGJDAbDIaqPDIKEYB9eBktW1Ml2NE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)