UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'PfQ6vcG0kKYa22GzLdGeqgPobGGzlXBtaQrjM4mKGl4='
WHERE
key_id = '4d31dbf3a484359285c3f84377b6bcf31c87e0fcbd5992ab23b5413867b88a23'
AND (
token = 'PfQ6vcG0kKYa22GzLdGeqgPobGGzlXBtaQrjM4mKGl4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)