UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xTi117D0qJGI5/gUkw0TyKgyx7kCzAyrHqnXzeqXcig='
WHERE
key_id = 'cd74ebed822da1f2b63abc80656abf7f5def1660f409fbbdcf3c904f90bddf7a'
AND (
token = 'xTi117D0qJGI5/gUkw0TyKgyx7kCzAyrHqnXzeqXcig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)