UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZnTedb/vk5CgAHiJSaX1Npf6SsqquaDf5ALWvy6/VZ4='
WHERE
key_id = 'f7f3011bda8af6e43ee58a8d2d2ed841a0befc4e5021759c281588e179be41f9'
AND (
token = 'ZnTedb/vk5CgAHiJSaX1Npf6SsqquaDf5ALWvy6/VZ4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)