UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pRnVHUvj705VLqe6zUQ/TugTpbuv/rd3qbTKYNMMUg0='
WHERE
key_id = 'd8a4e0890b7f6b68ebaeb14db27ac17e7682870ae66b0c0c03aa4c3cf0329725'
AND (
token = 'pRnVHUvj705VLqe6zUQ/TugTpbuv/rd3qbTKYNMMUg0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)