UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZNfV/IoMPCniRKnQqdeQ4ghVDkgWkb5i0VqSoZCbcZc='
WHERE
key_id = '07da7dca8f817952b5d4756d4deb7459fdee0a682cea344857bfbfa59aabf580'
AND (
token = 'ZNfV/IoMPCniRKnQqdeQ4ghVDkgWkb5i0VqSoZCbcZc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)