UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZyLiPfzljCFH3E5FaOXBnHjF6z0+yZ+0OVGfAcwbLUo='
WHERE
key_id = 'd92fa6763fe859259c017f11d23689751e4d6efd20ee8108d5d0d4f19e5b8167'
AND (
token = 'ZyLiPfzljCFH3E5FaOXBnHjF6z0+yZ+0OVGfAcwbLUo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)