UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/ZxVpUtOQgibui8cvX7r3/UxeEb9aaeRvX8si7fgbOk='
WHERE
key_id = '821ffb882d800b560f11d54e0e38cea7005d6c592c612facec3b5ee9e1992d50'
AND (
token = '/ZxVpUtOQgibui8cvX7r3/UxeEb9aaeRvX8si7fgbOk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)