UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0VPE1Wmlcfuszvu3icYbAxs1lgc16q6xosgePoPvJsk='
WHERE
key_id = '1aefd52296b38bf19fced696e12f7d5bc272b0a45f9c7cea9dbbfc206fa4c6f7'
AND (
token = '0VPE1Wmlcfuszvu3icYbAxs1lgc16q6xosgePoPvJsk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)